s@lm@n
Oracle
Exam 1z0-144
Oracle Database 11g: Program with PL/SQL
Version: 8.5
[ Total Questions: 103 ]
http://certkill.com
What is the correct definition of the persistent state of a packaged variable?
A. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.
B. It is a public variable in a package specification whose value is consistent within a user
session.
C. It is a private variable in a package body whose value is consistent across all current
active sessions.
D. It is a public variable in a package specification whose value is always consistent across
all current active sessions.
Answer: B
View Exhibit1 and examine the structure of the employees table.
View Exhibit2 and examine the code.
Question No : 1
Question No : 2
Oracle 1z0-144 : Practice Test
2
http://certkill.com
What is the outcome when the code is executed?
A. Both blocks compile and execute successfully when called.
B. Both blocks compile successfully but the CALC_SAL procedure gives an error on
execution.
C. The CALC_SAL procedure gives an error on compilation because the amt variable
should be declared in the RAISE_SALARY procedure.
D. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY
procedure cannot call the stand-alone increase function.
Answer: A
View the Exhibit and examine the structure of the EMP table.
Question No : 3
Oracle 1z0-144 : Practice Test
3
http://certkill.com
You want to create two procedures using the overloading feature to search for employee
details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used
successfully? (Choose two.)
A. The procedures can be either stand-alone or packaged.
B. The procedures should be created only as packaged subprograms
C. The procedures should be created only as stand-alone subprograms
D. Each subprogram's formal parameters should differ in both name and data type.
E. The formal parameters of each subprogram should differ in data type but can use the
same names.
Answer: B,E
View the exhibit to examine the PL/SQL code.
Question No : 4
Oracle 1z0-144 : Practice Test
4
http://certkill.com
Which statement is true about the exception handlers in the PL/SQL code?
A. All the exceptions in the code are trapped by the exception handler.
B. All the "no data found" errors in the code are trapped by the exception handler.
C. The PL/SQL program does not execute because an exception is not declared in the
declare section.
D. An exception handler in the code traps the "no data found" error after executing the
handler code and the program flow returns to the next line of code.
Answer: B
You want to maintain an audit of the date and time when each user of the database logs
off.
Examine the following code:
Question No : 5
Oracle 1z0-144 : Practice Test
5
http://certkill.com
Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)
A. ON SCHEMA
B. ON QRXABASE
C. AFTER LOGOFF
D. BEFORE LOGOFF
Answer: A,D
Which statements are true about PL/SQL procedures? (Choose all that apply.)
A. Users with definer's rights who are granted access to a procedure that updates a table
must be granted access to the table itself.
B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the
server avoids the parsing overhead of SQL statements at run time.
C. Depending on the number of calls, multiple copies of the procedure are loaded into
memory for execution by multiple users to speed up performance.
D. A PL/SQL procedure executing on the Oracle database can call an external procedure
or function that is written in a different programming language, such as C or Java.
Answer: B,D
Question No : 6
Question No : 7
Oracle 1z0-144 : Practice Test
6
http://certkill.com
Which statements are true about database triggers? (Choose all that apply.)
A. They can invoke only PL/SQL procedures
B. They can include SQL and PL/SQL or calls to Java procedures.
C. They are implicitly fired by an event that must occur within an application
D. They are implicitly fired when a triggering event occurs, depending on which user is
connected
Answer: A,D
Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch15.htm
View the Exhibit and examine the package code created by SCOTT. The execute privilege
on this package is granted to green.
Question No : 8
Oracle 1z0-144 : Practice Test
7
http://certkill.com
Examine the following sequence of commands issued by SCOTT:
What is the outcome?
A. SCOTT’S session displays 5, and then 0, greets session displays 0.
B. SCOTT’S session displays 5, and then 0; green's session displays 5.
C. SCOTT’S session displays 5, and then 5 again, green's session displays 0.
D. SCOTT’S session displays 5, and then 5 again; green's session displays 5.
Answer: B
Examine the following code:
What is the outcome?
Question No : 9
Oracle 1z0-144 : Practice Test
8
http://certkill.com
A. The procedure is created successfully and displays the values 20 and 30 when it is
called.
B. The procedure gives errors because the parameters should be in out mode.
C. The procedure gives errors because the host variables cannot be referenced anywhere
in the definition of a PL/SQL stored procedure.
D. The procedure is created successfully but does not display any values when it is called
because the host variables cannot be displayed inside the procedure.
Answer: C
View the Exhibit and examine the structure of the customer table.
You create the following trigger to ensure that customers belonging to category "A" or "B"
in the customer table can have a credit limit of more than 8000.
What is the outcome?
Question No : 10
Oracle 1z0-144 : Practice Test
9
http://certkill.com
A. The trigger is fired, a message is displayed, and the update is successful
B. The trigger is fired and a message is displayed, but the update is rolled back.
C. The trigger is not fired because the when clause should be used to specify the condition,
however, the update is successful.
D. The trigger is not fired because column names must be specified with the update event
to identify which columns must be changed to cause the trigger to fire, however, the update
is successful.
Answer: D
Which two statements are correct about PL/SQL package components? (Choose two)
A. A package must have both specification and body.
B. A package body can exist without the package specification.
C. A package specification can exist without the package body.
D. When a packaged public variable is called for the first time in a session, the entire
package is loaded into memory.
Answer: C,D
Which system events can be used to create triggers that fire both at database and schema
levels? (Choose all that apply)
A. AFTER LOGON
B. AFTER STARTUP
C. BEFORE SHUTDOWN
D. AFTER SERVERERROR
Answer: A,D
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
Question No : 11
Question No : 12
Oracle 1z0-144 : Practice Test
10
http://certkill.com